package com.koi.web.controller.demo.easyexecl;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.math.BigDecimal;

/**
 * @author ･ᴗ･
 * @description [PayBillInfoExportBo]
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@ContentRowHeight(15)
@HeadRowHeight(17)
public class PayBillInfoExportBo implements Serializable {

    @ColumnWidth(60)
    @ExcelProperty("类型")
    private String orderClassStr;

    @ColumnWidth(60)
    @ExcelProperty("房号")
    private String houseAddress;

    @ColumnWidth(60)
    @ExcelProperty("账单单号")
    private String payNo;

    @ColumnWidth(60)
    @ExcelProperty("账单生辰时间")
    private String createDate;

    @ColumnWidth(60)
    @ExcelProperty("计算金额")
    private BigDecimal sumCalAmount;

    @ColumnWidth(60)
    @ExcelProperty("优惠金额")
    private BigDecimal sumPValue;

    @ColumnWidth(60)
    @ExcelProperty("违约金")
    private BigDecimal sumBreachValue;

    @ColumnWidth(60)
    @ExcelProperty("应收金额")
    private BigDecimal sumActualAmount;

    @ColumnWidth(60)
    @ExcelProperty("录入人")
    private String creatorName;

    @ColumnWidth(60)
    @ExcelProperty("账单状态")
    private String payStateStr;

    // @ExcelIgnore    此注解表示忽略这个字段
    // @DateTimeFormat("yyyy年MM月dd日HH时mm分ss秒")  时间格式化注解
    // @NumberFormat("#.##%")  百分比表示
    // @ColumnWidth(50)   设置单元格宽度为50
    // @ExcelProperty(value = "标题", index = 0)   第0列为标题列
}

